Join discussion: http://www.techtud.com/video-lecture/understanding-group-clause-sqlIMPORTANT LINKS:1 ... ... <看更多>

When you use a group by on the subject column only; say: ... SQL script examples about using aggregate functions: Let's say we need to find the sale orders ... ... <看更多>

Grouping is drawing a line across the table where the values change: ... When you do SQL is treating the table as one big group and when you add in the ... ... <看更多>

In SQL queries, we do use Group by clause to apply aggregate functions. But what is the purpose behind using numeric value instead of column name with Group by ... ... <看更多>